2017-05-06 - 29708 - Service Request - BW Identify current available fields in Master data and Transaction Data #BWonHANAUpgrade

29708 - BW Identify current fields for Customer, Material, and Vendor Master,Transaction data.

Problem Summary

Need to Identify available fields in BW Master data for 0CUSTOMER, 0CUST_SALES, 0MATERIAL, 0MAT_SALES, 0MAT_PLANT, 0VENDOR and Transaction data fields for AFS Sales order DSO, Open Orders infocube, Inventory infocube, Purchase Order Items infocube, and Retail Pro Point of Sale NA.
.

Admin Info

Purpose	Identify available fields in BW Master data & Transaction Data.
Requested by	Mark Harris
Issue Date	05-02-2017
Resolved by	Uday Kumar P
Resolved Date	05-06-2017
Document Status	Completed

Detailed Problem Description

Need to Identify available fields in BW Master data objects:
1. 0CUSTOMER
2. 0CUST_SALES
3. 0MATERIAL
4. 0MAT_SALES
5. 0MAT_PLANT
6. 0VENDOR

Need to Identify available fields in Transaction data sources:
1. AFS Sales order DSO
2. Open Orders infocube
3. Inventory infocube
4. Purchase Order Items infocube.
5. Retail Pro Point of Sale NA

Solution Analysis and Recommendations

Listed the available fields in BW Master data objects:
1. 0CUSTOMER
2. 0CUST_SALES
3. 0MATERIAL
4. 0MAT_SALES
5. 0MAT_PLANT
6. 0VENDOR

Listed the available fields in Transaction data sources:
1. AFS Sales order DSO
2. Open Orders infocube
3. Inventory infocube
4. Purchase Order Items infocube.
5. Retail Pro Point of Sale NA

Resolution

The list of fields in the various master data and transaction data sources are attached here for reference:

Master data fields.xlsx Transaction data fields.xlsx

Release Information

None